1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Controllers
12 {
13 class KhoCtrl
14 {
15
16 // Method Add
17 public static int InsertKho(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, string _MaVietTat,float _ThueBanHang, float _ChietKhauPTBanHang, float _SoLuongDaBan)
18 {
19 try
20 {
21 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _TenSanPham, _NhomSanPhamId, _DonViTinhId, _DanhMucId, _NhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _MaVietTat, _ThueBanHang, _ChietKhauPTBanHang,_SoLuongDaBan);
22 return kho.InsertKho();
23 }
24 catch
25 {
26 return 0;
27 }
28 }
29
30
31 //insert by id kho
32 public static int InsertKho_Select_ByIdKho(int _IdKho, string _MaSanPham, string _MaVietTat, string _TenSanPham, double _SoLuong)
33 {
34 try
35 {
36 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _MaVietTat, _TenSanPham, _SoLuong);
37 return kho.InsertKho_Select_ByIdKho();
38 }
39 catch
40 {
41 return 0;
42 }
43
44 }
45
46 //insert by nhap nhanh
47 public static int InsertKho_Select_NhapNhanh_ByNhapHangId(string _MaSanPham, int _NhapHangId, string _MaVietTat)
48 {
49 try
50 {
51 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
52 return kho.InsertKho_Select_NhapNhanh_ByNhapHangId();
53 }
54 catch
55 {
56 return 0;
57 }
58
59 }
60
61 // Method Update
62 public static int UpdateKho(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, string _MaVietTat, float _ThueBanHang, float _ChietKhauPTBanHang, float _SoLuongDaBan)
63 {
64 try
65 {
66 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _TenSanPham, _NhomSanPhamId, _DonViTinhId, _DanhMucId, _NhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _MaVietTat, _ThueBanHang, _ChietKhauPTBanHang, _SoLuongDaBan);
67 return kho.UpdateKho();
68 }
69 catch
70 {
71 return 0;
72 }
73
74 }
75
76 //Update thue
77 // Method Update
78 public static int UpdateKho_Thue(int _IdKho, double _Thue)
79 {
80 try
81 {
82 Models.KhoMod kho = new Models.KhoMod(_IdKho, _Thue);
83 return kho.UpdateKho_Thue();
84 }
85 catch
86 {
87 return 0;
88 }
89
90 }
91
92 //update nha cung cap
93 public static int UpdateKho_NhaCungCapId(int _IdKho, int _NhaCungCapId, int _NhapHangId)
94 {
95 try
96 {
97 Models.KhoMod kho = new Models.KhoMod(_IdKho, _NhaCungCapId, _NhapHangId);
98 return kho.UpdateKho_NhaCungCapId();
99 }
100 catch
101 {
102 return 0;
103 }
104
105 }
106
107 //update nhacc and trang thai
108
109 public static int UpdateKho_NhaCungCapId_TrangThai_ByNhapHangId(int _IdKho, int _NhaCungCapId, string _TrangThai, int _NhapHangId)
110 {
111 try
112 {
113 Models.KhoMod kho = new Models.KhoMod(_IdKho, _NhaCungCapId, _TrangThai,_NhapHangId);
114 return kho.UpdateKho_NhaCungCapId_TrangThai_ByNhapHangId();
115 }
116 catch
117 {
118 return 0;
119 }
120
121 }
122 //update thiet lap gia
123 public static int UpdateKho_ThietLapGia(int _IdKho, string _MaVietTat, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, double _ThueBanHang, double _ChietKhauPTBanHang)
124 {
125 try
126 {
127 Models.KhoMod kho = new Models.KhoMod( _IdKho, _MaVietTat, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _ThueBanHang, _ChietKhauPTBanHang);
128 return kho.UpdateKho_ThietLapGia();
129 }
130 catch
131 {
132 return 0;
133 }
134
135 }
136
137 //thiet lap gia theo ma san pham hoac ma viet tat
138 public static int UpdateKho_ThietLapGiaBy_MaSanPham_MaVietTat(int _IdKho, string _MaSanPham, string _MaVietTat, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, double _ThueBanHang, double _ChietKhauPTBanHang)
139 {
140 try
141 {
142 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _MaVietTat, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _ThueBanHang, _ChietKhauPTBanHang);
143 return kho.UpdateKho_ThietLapGiaBy_MaSanPham_MaVietTat();
144 }
145 catch
146 {
147 return 0;
148 }
149
150 }
151
152
153 //update maviettat và ma san pham
154 public static int UpdateKho_ByMaSanPham_MaVietTat(int _IdKho, string _MaSanPham, string _MaVietTat, string _TenSanPham, double _SoLuong)
155 {
156 try
157 {
158 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _MaVietTat, _TenSanPham, _SoLuong);
159 return kho.UpdateKho_ByMaSanPham_MaVietTat();
160 }
161 catch
162 {
163 return 0;
164 }
165
166 }
167
168
169 //update trang thai by nhap hang
170
171 public static int UpdateKho_TrangThai_ByNhapHang(int _IdKho, int _NhapHangId, string _TrangThai)
172 {
173 try
174 {
175 Models.KhoMod kho = new Models.KhoMod(_IdKho, _NhapHangId, _TrangThai);
176 return kho.UpdateKho_TrangThai_ByNhapHang();
177 }
178 catch
179 {
180 return 0;
181 }
182
183 }
184
185 //update soluong da ban
186 public static int UpdateKho_SoLuongDaBan_ByIdKho(int _IdKho, float _SoLuong, float _SoLuongDaBan)
187 {
188 try
189 {
190 Models.KhoMod kho = new Models.KhoMod(_IdKho, _SoLuong, _SoLuongDaBan);
191 return kho.UpdateKho_SoLuongDaBan_ByIdKho();
192 }
193 catch
194 {
195 return 0;
196 }
197
198 }
199
200 //update san pham cho form nhap hang
201 public static int UpdateKho_FormNhapHang(int _IdKho, string _MaSanPham, string _MaVietTat, string _TenSanPham, int _DonViTinhId, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, string _ChietKhauTheo, double _TienChietKhau)
202 {
203 try
204 {
205 Models.KhoMod kho = new Models.KhoMod( _IdKho, _MaSanPham, _MaVietTat, _TenSanPham, _DonViTinhId, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _ChietKhauTheo, _TienChietKhau);
206 return kho.UpdateKho_FormNhapHang();
207 }
208 catch
209 {
210 return 0;
211 }
212
213 }
214
215 // Method Delete
216 public static int DeleteKho(int _IdKho)
217 {
218 try
219 {
220 Models.KhoMod kho = new Models.KhoMod(_IdKho);
221 return kho.DeleteKho();
222 }
223 catch
224 {
225 return 0;
226 }
227 }
228
229 //Select
230 public static DataSet FillDataSet_getKho_ByMaSanPham(string _maSanPham)
231 {
232 try
233 {
234 Models.KhoMod kho = new Models.KhoMod(_maSanPham);
235 return kho.FillDataSet_getKho_ByMaSanPham();
236
237 }
238 catch
239 {
240 return null;
241 }
242 }
243
244 //ma san pham hoac ma viet tat
245 public static DataSet FillDataSet_getKho_ByMaSanPham_OrMaVietTat(string _maSanPham)
246 {
247 try
248 {
249 Models.KhoMod kho = new Models.KhoMod(_maSanPham);
250 return kho.FillDataSet_getKho_ByMaSanPham_OrMaVietTat();
251
252 }
253 catch
254 {
255 return null;
256 }
257 }
258
259 //lay san pham khong ton tai idkho
260
261 public static DataSet FillDataSet_getKho_ByMaSanPhamByNotInIdKho(int _IdKho, string _maSanPham, int _khachHangId)
262 {
263 try
264 {
265 Models.KhoMod kho = new Models.KhoMod(_IdKho, _maSanPham, _khachHangId);
266 return kho.FillDataSet_getKho_ByMaSanPhamByNotInIdKho();
267
268 }
269 catch
270 {
271 return null;
272 }
273 }
274
275
276 //lay theo ma san pham va nhap hang id
277 public static DataSet FillDataSet_getKho_ByMaSanPham_ByNhapHangId(string _maSanPham, int _nhapHangId)
278 {
279 try
280 {
281 Models.KhoMod kho = new Models.KhoMod(_maSanPham, _nhapHangId);
282 return kho.FillDataSet_getKho_ByMaSanPham_ByNhapHangId();
283
284 }
285 catch
286 {
287 return null;
288 }
289 }
290
291 //lay theo ma viet tat
292 public static DataSet FillDataSet_getKho_ByMaSanPham_ByNhapHangId_MaVietTat(string _maSanPham, int _nhapHangId, string _maVietTat)
293 {
294 try
295 {
296 Models.KhoMod kho = new Models.KhoMod(_maSanPham, _nhapHangId, _maVietTat);
297 return kho.FillDataSet_getKho_ByMaSanPham_ByNhapHangId_MaVietTat();
298
299 }
300 catch
301 {
302 return null;
303 }
304 }
305
306 //Hien thi danh sach trong kho by NhapHangId
307 public static DataSet FillDataSet_getKho_ByNhapHangId(int _idKho, int _nhapHangId, int _pageSize, int _pageIndex)
308 {
309 try
310 {
311 Models.KhoMod kho = new Models.KhoMod(_idKho, _nhapHangId, _pageSize, _pageIndex);
312 return kho.FillDataSet_getKho_ByNhapHangId();
313 }
314 catch
315 {
316 return null;
317 }
318 }
319
320 //Hien thi danh sach trong kho by NhapHangId
321 public static DataSet FillDataSet_getKho_AllSearch(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, int _pageSize, int _pageIndex)
322 {
323 try
324 {
325 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _TenSanPham, _NhomSanPhamId, _DonViTinhId, _DanhMucId, _NhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _pageSize, _pageIndex);
326 return kho.FillDataSet_getKho_AllSearch();
327 }
328 catch
329 {
330 return null;
331 }
332 }
333
334 public static DataSet FillDataSet_getKho_AllSearch_ByHaving(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, int _pageSize, int _pageIndex)
335 {
336 try
337 {
338 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _TenSanPham, _NhomSanPhamId, _DonViTinhId, _DanhMucId, _NhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _pageSize, _pageIndex);
339 return kho.FillDataSet_getKho_AllSearch_ByHaving();
340 }
341 catch
342 {
343 return null;
344 }
345 }
346
347 //danh sach ton kho
348 public static DataSet FillDataSet_getKho_AllSearch_ByHaving_Hai(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, int _pageSize, int _pageIndex)
349 {
350 try
351 {
352 Models.KhoMod kho = new Models.KhoMod(_IdKho, _MaSanPham, _TenSanPham, _NhomSanPhamId, _DonViTinhId, _DanhMucId, _NhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _pageSize, _pageIndex);
353 return kho.FillDataSet_getKho_AllSearch_ByHaving_Hai();
354 }
355 catch
356 {
357 return null;
358 }
359 }
360
361 //Select
362 public static DataSet FillDataSet_getKho_ByIdKho(int IdKho)
363 {
364 try
365 {
366 Models.KhoMod kho = new Models.KhoMod(IdKho);
367 return kho.FillDataSet_getKho_ByIdKho();
368
369 }
370 catch
371 {
372 return null;
373 }
374 }
375
376 //next back
377 public static DataSet FillDataSet_getKho_ByIdKho_Next_Back(int IdKho)
378 {
379 try
380 {
381 Models.KhoMod kho = new Models.KhoMod(IdKho);
382 return kho.FillDataSet_getKho_ByIdKho_Next_Back();
383
384 }
385 catch
386 {
387 return null;
388 }
389 }
390
391 public static DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat(string _MaSanPham, int _NhapHangId, string _MaVietTat)
392 {
393 try
394 {
395 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
396 return kho.FillDataSet_getKho_ByMaSanPham_MaVietTat();
397
398 }
399 catch
400 {
401 return null;
402 }
403 }
404
405 public static DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat_All(string _MaSanPham, int _NhapHangId, string _MaVietTat)
406 {
407 try
408 {
409 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
410 return kho.FillDataSet_getKho_ByMaSanPham_MaVietTat_All();
411
412 }
413 catch
414 {
415 return null;
416 }
417 }
418
419
420 //lay cac san pham ton kho
421 public static DataSet FillDataSet_GetSCac_SP_TonKho_ByMaSanPham(string _MaSanPham, int _NhapHangId, string _MaVietTat)
422 {
423 try
424 {
425 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
426 return kho.FillDataSet_GetSCac_SP_TonKho_ByMaSanPham();
427
428 }
429 catch
430 {
431 return null;
432 }
433 }
434
435
436 //kiem tra tồn tại
437 public static DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat_KiemTraTonTai(string _MaSanPham, int _NhapHangId, string _MaVietTat)
438 {
439 try
440 {
441 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
442 return kho.FillDataSet_getKho_ByMaSanPham_MaVietTat_KiemTraTonTai();
443 }
444 catch
445 {
446 return null;
447 }
448 }
449
450 //lay theo ma viet tat
451 public static DataSet FillDataSet_getKho_ByMaVietTat(string _MaSanPham, int _NhapHangId, string _MaVietTat)
452 {
453 try
454 {
455 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
456 return kho.FillDataSet_getKho_ByMaVietTat();
457 }
458 catch
459 {
460 return null;
461 }
462 }
463
464 //tong mat hang trong kho
465 public static DataSet FillDataSet_getKho_COUNT_ByMaVietTat(string _MaSanPham, int _NhapHangId, string _MaVietTat)
466 {
467 try
468 {
469 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
470 return kho.FillDataSet_getKho_COUNT_ByMaVietTat();
471 }
472 catch
473 {
474 return null;
475 }
476 }
477
478 //tin so luong ton kho
479 public static DataSet FillDataSet_getKho_Gets_ByMaVietTatTongTonKho(string _MaSanPham, int _NhapHangId, string _MaVietTat)
480 {
481 try
482 {
483 Models.KhoMod kho = new Models.KhoMod(_MaSanPham, _NhapHangId, _MaVietTat);
484 return kho.FillDataSet_getKho_Gets_ByMaVietTatTongTonKho();
485 }
486 catch
487 {
488 return null;
489 }
490 }
491
492 //danh sach san pham trong kho theo ma viet tat
493 public static DataSet FillDataSet_getKho_GetSCac_SP_TonKho_ByMaSanPham_Search(string _MaVietTat, int _pageSize, int _pageIndex)
494 {
495 try
496 {
497 Models.KhoMod kho = new Models.KhoMod(_MaVietTat, _pageSize, _pageIndex);
498 return kho.FillDataSet_getKho_GetSCac_SP_TonKho_ByMaSanPham_Search();
499 }
500 catch
501 {
502 return null;
503 }
504 }
505
506 }
507 }